package rsj.sql.remind;

import com.rlyy.aibase.utils.base.Node;
import com.rlyy.aibase.utils.base.TableNode;
import rsj.annotation.Param;
import rsj.annotation.Select;

/**
 * @author : shibixiao
 * @description :
 * @date : 2021-07-19 16:55
 **/
public interface RemindLogDao {

    /**
     * 日志数
     *
     * @return {@link Node}
     */
    @Select(value = "SELECT COUNT(*) FROM sys.sys_remind_log")
    Node logCount();

    @Select(value = "SELECT remind_tm,remind_type,remind_mode,receive_user,remind_content,remind_status,fail_reason " +
            " FROM sys.sys_remind_log ORDER BY remind_tm DESC LIMIT #{limit} OFFSET #{offset}")
    TableNode listByPage(@Param(value = "limit")long limit, @Param(value = "offset")long offset);
}
